package com.example.demo.mapper;

import com.example.demo.entity.Source;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TreemapMapper {

    @Select("select stu_class,count(stu_id)as countId from dashuju group by stu_class ")
    List<Source> getDashujuTreeMap();

    @Select("select stu_class,count(stu_id)as countId from jisuanjiyingyong group by stu_class")
    List<Source> classJisuanjiyingyongTreeMap();//计算机应用

    @Select("select stu_class,count(stu_id)as countId from ruanjiangongcheng group by stu_class")
    List<Source> classRuanjiangongchengTreeMap();//软件工程

    @Select("select stu_class,count(stu_id)as countId from ruanjianjishu group by stu_class")
    List<Source> classRuanjianjishuTreeMap();//软件技术

    @Select("select stu_class,count(stu_id)as countId from wangluogongcheng group by stu_class")
    List<Source> classWangluogongchengTreeMap();//网络工程

    @Select("select stu_class,count(stu_id)as countId from wangluojishu group by stu_class")
    List<Source> classWangluojishuTreeMap();//网络技术

    @Select("select stu_class,count(stu_id)as countId from wulianwang group by stu_class")
    List<Source> classWulianwangTreeMap();//物联网

    @Select("select stu_class,count(stu_id)as countId from xinxiguanli group by stu_class")
    List<Source> classXinxiguanliTreeMap();//信息管理
}
